package com.atung.provider;

import java.util.Objects;

import org.apache.ibatis.annotations.Param;

public class AdmSchoolProvider {
	
	public String selectSchoolNameLikeAllProvider(@Param("schoolName")String schoolName){
		
		
		StringBuffer sql=new StringBuffer();
		sql.append("select * from adm_school where is_delect =0  and is_employ=0 ");
		if(Objects.nonNull(schoolName)){
			 
			sql.append(" and  school_name like concat('%',#{schoolName},'%');");
		}
		return sql.toString();
		
	}

}